/********************************************************************************************
** Copyright � 2011 Nokia Corporation. All rights reserved.
** Nokia and Nokia Connecting People are registered trademarks of Nokia Corporation.
** Java and all Java-based marks are trademarks or registered trademarks of
** Sun Microsystems, Inc. Other product and company names mentioned herein may be
** trademarks or trade names of their respective owners.
**
** Subject to the conditions below, you may, without charge:
**
** �  Use, copy, modify and/or merge copies of this software and
**    associated content and documentation files (the �Software�)
**
** �  Publish, distribute, sub-licence and/or sell new software
**    derived from or incorporating the Software.
**
** Some of the documentation, content and/or software maybe licensed under open source
** software or other licenses.  To the extent such documentation, content and/or
** software are included, licenses and/or other terms and conditions shall apply
** in addition and/or instead of this notice. The exact terms of the licenses, disclaimers,
** acknowledgements and notices are reproduced in the materials provided.
**
** This file, unmodified, shall be included with all copies or substantial portions
** of the Software that are distributed in source code form.
**
** The Software cannot constitute the primary value of any new software derived
** from or incorporating the Software.
**
** Any person dealing with the Software shall not misrepresent the source of the Software.
**
** THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED,
** INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A
** PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
** HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
** OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE
** SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
********************************************************************************************/
.pragma library

var db = null;

function openDB()
{
    if (db == null)
    {
        db = openDatabaseSync("KARPODB", "1.0", "Karpo local database", 1000000);
    }
    return db;
}




/*
    Save personal data given as JSON object

    data["username"]
    data["password"]
    data["karpoid"]
    data["firstname"]
    data["lastname"]
    data["hometown"]
    data["phone"]
    data["profile"]

*/
function savePersonalData(userdata)
{
    var dbhandle = openDB();
    dbhandle.transaction(
                function(tx) {
                    // Create the table if it doesn't already exist
                    tx.executeSql('CREATE TABLE IF NOT EXISTS PersonalData(data TEXT)');

                    // Find out if there already is the previous data
                    var rs = tx.executeSql('SELECT * FROM PersonalData');
                    if (rs.rows.length > 0)
                    {
                        // Update personal data row
                        tx.executeSql('UPDATE PersonalData SET data = ?', [ JSON.stringify(userdata) ]);
                    }
                    else
                    {
                        // Add personal data row
                        tx.executeSql('INSERT INTO PersonalData VALUES(?)', [ JSON.stringify(userdata) ]);
                    }
                }
                )
}

function getPersonalData(readcb)
{
    var dbhandle = openDB();

    dbhandle.transaction(
                function(tx) {
                    // Create the table if it doesn't already exist
                    tx.executeSql('CREATE TABLE IF NOT EXISTS PersonalData(data TEXT)');

                    var data = null;
                    // Find out if there already is the previous data
                    var rs = tx.executeSql('SELECT * FROM PersonalData');
                    if (rs.rows.length > 0)
                    {
                        console.log("DATABASE: \r\n" + rs.rows.item(0).data);
                        data = JSON.parse(rs.rows.item(0).data);
                    }

                    readcb(data);
                }
                )
}


/*
    Save privacy settings

    privacydata["showname"]
    privacydata["showphone"]
    privacydata["showhometown"]

*/
function savePrivacySettings(privacydata)
{
    var dbhandle = openDB();
    dbhandle.transaction(
                function(tx) {
                    // Create the table if it doesn't already exist
                    tx.executeSql('CREATE TABLE IF NOT EXISTS PrivacySettings(data TEXT)');

                    // Find out if there already is the previous data
                    var rs = tx.executeSql('SELECT * FROM PrivacySettings');
                    if (rs.rows.length > 0)
                    {
                        // Update privacy settings data row
                        tx.executeSql('UPDATE PrivacySettings SET data = ?', [ JSON.stringify(privacydata) ]);
                    }
                    else
                    {
                        // Add privacy settings data row
                        tx.executeSql('INSERT INTO PrivacySettings VALUES(?)', [ JSON.stringify(privacydata) ]);
                    }
                }
                )
}

function getPrivacySettings(readcb)
{
    var dbhandle = openDB();

    dbhandle.transaction(
                function(tx) {
                    // Create the table if it doesn't already exist
                    tx.executeSql('CREATE TABLE IF NOT EXISTS PrivacySettings(data TEXT)');

                    var data = null;
                    // Find out if there already is the previous data
                    var rs = tx.executeSql('SELECT * FROM PrivacySettings');
                    if (rs.rows.length > 0)
                    {
                        console.log("DATABASE: \r\n" + rs.rows.item(0).data);
                        data = JSON.parse(rs.rows.item(0).data);

                    }
                    else
                    {
                        data = JSON.parse("{\"showname\":\"0\",\"showphone\":\"0\",\"showhometown\":\"0\"}")
                    }

                    readcb(data);
                }
                )
}

/*
    Save settings

    data["datacloudurl"]
    data["uselastlogin"]
    data["logindone"]

*/
function saveSettings(data)
{
    var dbhandle = openDB();
    dbhandle.transaction(
                function(tx) {
                    // Create the table if it doesn't already exist
                    tx.executeSql('CREATE TABLE IF NOT EXISTS Settings(data TEXT)');

                    // Find out if there already is the previous data
                    var rs = tx.executeSql('SELECT * FROM Settings');
                    if (rs.rows.length > 0)
                    {
                        // Update Settings data row
                        tx.executeSql('UPDATE Settings SET data = ?', [ JSON.stringify(data) ]);
                    }
                    else
                    {
                        // Add Settings data row
                        tx.executeSql('INSERT INTO Settings VALUES(?)', [ JSON.stringify(data) ]);
                    }
                }
                )
}

function getSettings(readcb)
{
    var dbhandle = openDB();

    dbhandle.transaction(
                function(tx) {
                    // Create the table if it doesn't already exist
                    tx.executeSql('CREATE TABLE IF NOT EXISTS Settings(data TEXT)');

                    var data = null;
                    // Find out if there already is the previous data
                    var rs = tx.executeSql('SELECT * FROM Settings');
                    if (rs.rows.length > 0)
                    {
                        console.log("DATABASE: \r\n" + rs.rows.item(0).data);
                        data = JSON.parse(rs.rows.item(0).data);
                    }

                    readcb(data);
                }
                )
}
